| |
141 Search Results Found |
| 1 |
Forum: Marketplace «»
Posted on: Fri, 12 June 2020 12:15 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
DESCRIBE command
The DESCRIBE command is another way to get information about a Data Pump job.
The syntaxes of this command are:
McDP [<logon>] { -desc | --describe } [<schema>.]<dp job> [[-opt] <display/trace option>]
…
|
| 2 |
Forum: Forms «»
Posted on: Sat, 13 August 2022 03:29 «»
By: sasipalarivattom
Re: Files generated on server with sufix
…report in URL
like http://WIN-SERV:9002/reports/rwservlet?server=rep_server1&report=test.rdf&destype=file&desformat=html&userid=scott/ti ger@orcl&desname=c:\rep1.html
is it also appending something to the output file…
|
| 3 |
Forum: Forms «»
Posted on: Mon, 17 June 2019 10:44 «»
By: alhakimy
Re: How make imp button
…want
1- drop user
2- create user
3-grant dba to user
4- imp file.dmp
I used this code in 6i but now with 10g did not work
forms_ddl('conn system/manager');
forms_ddl('drop user scott cascade');
forms_ddl('create user scott identified by …
|
| 4 |
Forum: Marketplace «»
Posted on: Tue, 20 March 2018 05:47 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
COPY tables and views (new in version 2018.03.20)
This new McDP command allows you to copy tables and views from a schema to another or the same one, possibly renaming them or not (see Data Pump engine restrictions at the bottom of the page).
When …
|
| 5 |
Forum: Server Utilities «»
Posted on: Tue, 29 August 2017 10:59 «»
By: BlackSwan
Re: IMP-00010: not a valid export file, header failed verification
…>i think it was created by exp
You think wrongly.
exp does NOT have any DIRECTORY= parameter
[oracle@vbgeneric ~]$ exp help=yes
Export: Release 12.2.0.1.0 - Production on Tue Aug 29 11:57:27 2017
Copyright (c) 1982, 2017, Oracle and/or …
|
| 6 |
Forum: Server Utilities «»
Posted on: Fri, 30 December 2016 18:05 «»
By: Barbara Boehmer
Re: SQL Loader double quotes in clob data (3 threads from 2 sub-forums merged by bb)
…your control file, use:
infile * "str'AM'"
In your command line, where you specify data= ... your file path will be different from mine. I am using Windows, so I use \ instead of /. Also, if there are spaces or other unusual characters …
|
| 7 |
Forum: Server Utilities «»
Posted on: Thu, 29 December 2016 18:17 «»
By: Barbara Boehmer
Re: SQL Loader double quotes in clob data (3 threads from 2 sub-forums merged by bb)
…double quotes are not a problem.
The carriage returns do present a problem. You need to have some way to tell where the record ends, such as a record delimiter or something at the beginning or end of each row that tells if to continue or concatenating…
|
| 8 |
Forum: Marketplace «»
Posted on: Mon, 22 August 2016 10:14 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
USER command
The last command of the first version of McDP is not a real Data Pump command as it does not use its engine but it is a useful one for a requirement that is often asked to DBA: get the DDL to recreate one or several accounts, possibly …
|
| 9 |
Forum: Marketplace «»
Posted on: Mon, 22 August 2016 10:14 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
DDL command
In the same vein than the previous command, CONTENT, McDP allows you to get the DDL of all or part of a database, with the transformation you want, using the DDL command.
Its syntax is:
McDP [<logon>] { -ddl | --ddl } [<…
|
| 10 |
Forum: Marketplace «»
Posted on: Mon, 22 August 2016 10:13 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
CONTENT command
Now I want to know what's inside the dump, more I want the DDL, more I want not all but some of these DDL and I want to apply some transformation on them.
This is possible with McDP using the CONTENT command.
Its syntax is:
McDP…
|
| 11 |
Forum: Reports & Discoverer «»
Posted on: Mon, 24 March 2014 05:27 «»
By: pre_ora
Reports location or path
…t=D:\dummy_folder\reports-files\test.rdf&userid=scott/tiger@something &desformat=html&destype=cache
but Our senior recommends that report should run using only name of report...i.e;
http://machine:port/reports/rwservlet?server=sernm&…
|
| 12 |
Forum: Reports & Discoverer «»
Posted on: Fri, 25 October 2013 18:24 «»
By: suj_it
Re: How to Hide Username and Password in WEB.SHOW_DOCUMENT
…=RptSvr_app01_dvlp&destype=cache&desformat=pdf&report=audit_counts.rep&userid=scott/tiger@rwdvlp&end_date=25-OCT-2013&start_date=01-OCT-2013&p_auditor=ALL&p_hub=1099
I have not tried the cookie method suggested by dllinf…
|
| 13 |
Forum: JDeveloper, Java & XML «»
Posted on: Thu, 19 September 2013 14:04 «»
By: Barbara Boehmer
Re: XML issue
…looks like you figured it out while I was posting. I corrected a couple of mis-matched column names for the abc table, then put it all together below.
SCOTT@orcl12c> -- test data:
SCOTT@orcl12c> COLUMN pat_mrn FORMAT A7
SCOTT@orcl12c>…
|
| 14 |
Forum: Server Utilities «»
Posted on: Thu, 15 August 2013 12:07 «»
By: BlackSwan
Re: Error using parfile
…help=yes does NOT show CONSISTENT as be a valid option
what happens if you remove it from the control file.
[oracle@localhost ~]$ expdp help=yes
Export: Release 11.2.0.2.0 - Production on Thu Aug 15 10:05:38 2013
Copyright (c) 1982, 2009, …
|
| 15 |
Forum: Reports & Discoverer «»
Posted on: Mon, 01 July 2013 03:56 «»
By: samir2012
Re: How to Hide Username and Password in WEB.SHOW_DOCUMENT
…ervlet?';
v_connect VARCHAR2 (200) := 'userid=scott/tiger@test1';
v_report_server VARCHAR2 (50) := 'rep_tbanner';
v_report_name VARCHAR2(100) := '/u01/banner/inb/TEST/reports/rdf/GSTEST.rdf';
v_format VARCHAR2(12) := '…
|
| 16 |
Forum: Reports & Discoverer «»
Posted on: Tue, 04 September 2012 03:18 «»
By: new_oracle2011
Re: how to call report automatically
…ep_pda_server_frhome1+report=AUTO_REPORT.rdf+userid=scott/tiger@db.world+desformat= pdf+DESTYPE=mail+DESNAME="xyz@abc.com"=CC="xyz@abc.com"+BCC="xyz@abc.com"+REPLYTO="xyz@abc.com"+FROM="xyz@…
|
| 17 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 13 August 2012 05:10 «»
By: Littlefoot
Re: incrementally increasing userid value via looping
…then, here you are.
SQL> create table reg_user as
2 select ename from emp;
Table created.
SQL> alter table reg_user add userid number;
Table altered.
SQL> declare
2 cursor cur_e is
3 select ename from reg_user…
|
| 18 |
Forum: Server Utilities «»
Posted on: Wed, 25 July 2012 18:27 «»
By: alan.kendall@nfl.com
Re: Running exp and imp command on 11.2.0.1.0 Production version
…11g imports from prior Oracle Versions I have had some corruption issues so I have had to
truncate or drop partially imported tables and import the tables one at a time after doing individual
table exports.
SCOTT > @…
|
| 19 |
Forum: Server Utilities «»
Posted on: Mon, 16 July 2012 19:45 «»
By: alan.kendall@nfl.com
Re: Export Multiple tables only
…have used the following sql to generate exports with multiple tables in each export dump file. The backslash tells the Unix OS that the open parenthesis and the close parenthesis are not to parsed by the Unix OS. Also the backslash is added to each line …
|
| 20 |
Forum: Server Utilities «»
Posted on: Mon, 16 July 2012 19:18 «»
By: alan.kendall@nfl.com
Re: Export Multiple tables only
…use the following to export files from 9i one at a time from either Unix or Windows. You can modify the script to also create the imports as well.
SCOTT > @cr8_exports_by_TABLE_NAME_on_Unix.sql
exp userid=myschema_login/myschema_password file=…
|
| 21 |
Forum: Backup & Recovery «»
Posted on: Wed, 11 July 2012 01:30 «»
By: Michel Cadot
Re: Taking a dump of huge table
…classic "exp":
C:\>exp help=y
Export: Release 10.2.0.4.0 - Production on Mer. Juil. 11 08:27:45 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
You can let Export prompt you for parameters by entering the EXP
…
|
| 22 |
Forum: Reports & Discoverer «»
Posted on: Sun, 22 April 2012 17:30 «»
By: eng_amrelhanafy
Problem in printing pdf report
…print it , It prints normally .
The code I use to call report is
web.show_document('//localhost:8889/reports/rwservlet?server=rserver&report=rep1.rdf&destype=cache&desformat=pdf&userid=scott/tiger@orcl');
Could anybody help…
|
| 23 |
Forum: Server Utilities «»
Posted on: Sun, 15 April 2012 11:39 «»
By: BlackSwan
Re: Increasing parallel process in impdp in runtime
…
bcm@bcm-laptop:~$ impdp help=yes
Import: Release 11.2.0.1.0 - Production on Sun Apr 15 09:37:52 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
The Data Pump Import utility provides a mechanism for …
|
| 24 |
Forum: Reports & Discoverer «»
Posted on: Tue, 31 January 2012 07:02 «»
By: Littlefoot
Re: Error message when passing the report parameter from command line
… following example?
rwrun report=test.rdf userid=scott/tiger@mydb desformat=pdf DESTYPE=mail DESNAME="emp1@comp.com, emp2@comp.com"cc="emp3@comp.com"bcc="mgr@comp.com" replyto="me@comp.com" from="me@comp.com…
|
| 25 |
Forum: Forms «»
Posted on: Mon, 04 July 2011 12:07 «»
By: prasubh
Re: problem in running form on oracle developer suite 10g
…90/f90servlet?form=C:\praforms\form1.fmx&userid=SCOTT/TIGER@orcl&buffer_records=NO&debug_message s=NO&array=YES&query_only=NO&quiet=NO&RENDER=YES
and tnsnames.ora is
# tnsnames.ora Network Configuration File: C:\oracle\…
|
| 26 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Tue, 31 May 2011 05:40 «»
By: jamal_s
Re: Generating Scheduler for Some Procedures
…and password here and connectivity string
userid=scott/tiger@test
colorScheme=teal
splashScreen=no
lookandfeel=oracle
workingDirectory=c:\test
then save your formsweb.cfg
now you can call this form from your browser by
giveing
'your Ip':'…
|
| 27 |
Forum: Server Administration «»
Posted on: Wed, 25 May 2011 13:34 «»
By: Michel Cadot
Re: Deleting unwanted SYS shema objects
…- Never ever use SYS (or SYSDBA) but for maintenance purpose (startup, shutdown, backup, recover)
- SYS/SYSDBA is special
- SYS/SYSDBA is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS/SYSDBA" and you'll see the …
|
| 28 |
Forum: Server Utilities «»
Posted on: Wed, 08 December 2010 14:23 «»
By: Littlefoot
Re: Calling SQL*Loader utility with alias instead of password
…is OK - loads data):C:\TEMP>sqlldr userid=scott control=test.ctl log=test.log
Password:
SQL*Loader: Release 10.2.0.1.0 - Production on Sri Pro 8 21:19:56 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Commit point reached - …
|
| 29 |
Forum: Server Utilities «»
Posted on: Wed, 27 October 2010 06:52 «»
By: goracle9
Re: Upgrade 8i to 10g
…IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "RBS" DATAFILE 'C:\ORACLE\ORADATA\ARMADA\RBS01.DBF' SIZE"
" 545259520 AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M DEFAULT STORAG"
&…
|
| 30 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 16 September 2010 20:45 «»
By: Barbara Boehmer
Re: multi column distinct
…analytic function like row_number or rank is exactly what you need. You can use an analytic function to partition the rows by userid, lastname, and firstname, then number the rows within each such partition, ordered by rownum or rowid or whatever unique …
|
| 31 |
Forum: Forms «»
Posted on: Mon, 28 June 2010 06:17 «»
By: ranamirfan
To Hide UserName & Password in Reports11g - Urgent
…estype=cache desformat=html server=repserver userid=scott/tiger@mydb %P
;
Example 6: take all URL arguments, and also generate a HTML parameter form
runp: %* %P
;
Example 7: Run an Express Report. Replace <MYHOST> with the name of the …
|
| 32 |
Forum: Server Utilities «»
Posted on: Tue, 20 April 2010 02:54 «»
By: Michel Cadot
Re: Export Schema failed
…that are appropriate to what you want to export.
Maybe the following and the documentation may help you to know what to do:
C:\>exp help=y
Export: Release 10.2.0.4.0 - Production on Tue Apr 20 09:54:36 2010
Copyright (c) 1982, 2007, Oracle. …
|
| 33 |
Forum: Server Utilities «»
Posted on: Thu, 25 March 2010 08:47 «»
By: Michel Cadot
Re: How to export one table to few separated dump files?
…C:\>expdp help=y
Export: Release 10.2.0.4.0 - Production on Thursday, 25 March, 2010 14:45:55
Copyright (c) 2003, 2007, Oracle. All rights reserved.
The Data Pump export utility provides a mechanism for transferring data objects
between …
|
| 34 |
Forum: Server Utilities «»
Posted on: Mon, 25 January 2010 23:15 «»
By: BlackSwan
Re: can we do import like
…>my question is can i do import of particular table from full exported database file.
Yes, you can or at least I could.
Since you included no details, I can't provide any details in return.
imp help=yes
Import: Release 10.2.0.1.0 - …
|
| 35 |
Forum: Server Administration «»
Posted on: Mon, 11 January 2010 22:41 «»
By: BlackSwan
Re: Connection log for bequeath connection
…then did
SQL> CONNECT SCOTT/TIGER
which produced following audit log file
cat /u01/app/oracle/admin/v102/adump/ora_2278.aud
Audit file /u01/app/oracle/admin/v102/adump/ora_2278.aud
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - …
|
| 36 |
Forum: Reports & Discoverer «»
Posted on: Wed, 06 January 2010 10:00 «»
By: lkngstr82is
Re: REP-300 : 'invalid identifier SELECT ==>
…error:
rwclient server=rep_cio14-5394-b userid=scott/cis_test@cisdev report=test_report1.rdf destype=cache desformat=html empno=RPAD(ENAME,256)
Following are the codes:
QUERY:
SELECT &EMPNO REPORT FROM EMP
EMPNO has width of 256 …
|
| 37 |
Forum: Server Administration «»
Posted on: Sat, 26 December 2009 12:02 «»
By: Michel Cadot
Re: Moving subsets of data between servers
…you can use exp with the query clause on this id.
C:\>exp help=y
Export: Release 10.2.0.4.0 - Production on Sam. DÚc. 26 18:59:24 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
You can let Export prompt you for parameters by …
|
| 38 |
Forum: Weblogic & Application Server «»
Posted on: Thu, 10 December 2009 03:34 «»
By: annu-agi
Report_path On applicaiton server report services
… coding behind the button is as following
BEGIN
web.show_document('http://10.10.0.13:7778/reports/rwservlet?report=emp_list.rdf&userid=scott/tiger@amsdb_xe&destype=CACHE&desformat=html','_blank' );
END;
regards
Anwer…
|
| 39 |
Forum: Reports & Discoverer «»
Posted on: Wed, 02 December 2009 12:53 «»
By: Littlefoot
Re: Is it possible to Save Oracle Reports Output as PDF
… you are looking for:
rwrun report=test.rdf userid=scott/tiger@mydb desformat=pdf destype=file desname=c:\mydir\test.pdforhttp://myias.mycomp.com:7779/reports/rwservlet?server=myrepserv+report=test.rdf+userid=scott/tiger@mydb+desformat=pdf+destype=file+…
|
| 40 |
Forum: Server Utilities «»
Posted on: Thu, 08 October 2009 14:21 «»
By: BlackSwan
Re: impdp issue - ORA-02264
…
impdp -help
Import: Release 10.2.0.4.0 - Production on Thursday, 08 October, 2009 12:19:35
Copyright (c) 2003, 2007, Oracle. All rights reserved.
The Data Pump Import utility provides a mechanism for transferring data objects
between Oracle…
|
Blog
Search
Help
Members
Register
Login
Home